To back up a SQL Server vault database, use the Prepare for Backup Wizard the same as a Hypertrieve vault database as explained in Preparing for backups. With SQL Server as the database engine, BlueCielo SQLIO uses the SQL Server backup functions to create the backup files in the vault’s Backup folder. You can then back up the files in the Backup folder with standard backup software.
Warning Do not create vault database backups directly with SQL Server Enterprise Manager. The Prepare for Backup Wizard in Meridian Enterprise Administrator must be used in order to first commit the transaction logs that the EDM Server service generates. These are required for a complete backup.
To restore a backup of a SQL Server vault database, restore the backed up files from the backup media to the Backup folder and then use the Restart After Restore Wizard as described in Restoring backups. This ensures the integrity and compatibility of the database with the host computer.
Related concepts
Integrating Meridian with SQL Server
Understanding how Meridian works with SQL Server
Understanding vault cache memory
Related tasks
Integrating with a separate SQL Server computer
Configuring the Windows account used by Meridian
Creating a SQL Server account for use by Meridian
Configuring the SQL Server account used by Meridian
Migrating a Hypertrieve vault to SQL Server
Moving a SQL Server vault to a different folder
Restoring a SQL Server vault to another server